UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GNd5zaAw7F1BWbN59C+8dkp+HT9wQ3BogqlRPhhjoSw='
WHERE
key_id = '6d1729ee561f2b966d30c02b9a1b9c5313d0c58a8f05df3fdac2206b2900a066'
AND (
token = 'GNd5zaAw7F1BWbN59C+8dkp+HT9wQ3BogqlRPhhjoSw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)