UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HQ75cmAMdUe3oGLhME5qI0adEb7vaaSr9T3gnjvzVWc='
WHERE
key_id = 'e513caf1b75fe3089d631c54586da9666a0149094a5846d755b0ee92c7718136'
AND (
token = 'HQ75cmAMdUe3oGLhME5qI0adEb7vaaSr9T3gnjvzVWc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)