UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Cbkn3p2gM3rriIIej33gj1Bwml9iD47xPeb2Vs+qTo='
WHERE
key_id = 'e52c7fea6a199f9fea2557ce59854d441f8d266a55a95fe2fbfa3747dc391045'
AND (
token = '9Cbkn3p2gM3rriIIej33gj1Bwml9iD47xPeb2Vs+qTo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)