UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hpIm6SBDlUSCQS8JDzHP1B10AG+1yWrvFdrw2KEfsfw='
WHERE
key_id = 'bc2cf15469db246bcdbecf5ef2d2e2da3af4031838dce0ea085d05f49c3a27fe'
AND (
token = 'hpIm6SBDlUSCQS8JDzHP1B10AG+1yWrvFdrw2KEfsfw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)