UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EMTVsIoOBiJiXt/BcvTYOyov9PASp6vBHhv31bPK/Dk='
WHERE
key_id = 'd5c540657f5767bdef33e53df17ff94255ce73669927fe5d6b00c0b4f944510e'
AND (
token = 'EMTVsIoOBiJiXt/BcvTYOyov9PASp6vBHhv31bPK/Dk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)