UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WBHtYKpjQY26LbEjcRC0fzWQGfpO0lXVK5Tw1bkatCk='
WHERE
key_id = 'd518601444074a74a36ac5d3680b85bcd8832f8d20a774d7328b42c506723bd4'
AND (
token = 'WBHtYKpjQY26LbEjcRC0fzWQGfpO0lXVK5Tw1bkatCk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)