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