UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6ImcZjuBhCmcYSBmKXr0MfnY2Q6vfVFwbfli1DIAPgY='
WHERE
key_id = '054775eac84a2dd5dcee7b87fa64a82468b7b028a9a2e6366d3e87af92030270'
AND (
token = '6ImcZjuBhCmcYSBmKXr0MfnY2Q6vfVFwbfli1DIAPgY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)