UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jOVBlrfmb3XDwWDoTJIyeizEHZhJBEIBH1lGMsPiYDI='
WHERE
key_id = '27747fb4f272b0cbe5cf17b602aa0a9a54e966dd0e49eab3662d4445a2ba7a78'
AND (
token = 'jOVBlrfmb3XDwWDoTJIyeizEHZhJBEIBH1lGMsPiYDI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)