UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E1AgyO8UBTPgpxpFmUUeUR214SwRuFbNG/5QIG2ZA24='
WHERE
key_id = 'e9e9988f87706a0dfebf304b39950f1f0b47fe153b2689ff2d7769e2fcd902b3'
AND (
token = 'E1AgyO8UBTPgpxpFmUUeUR214SwRuFbNG/5QIG2ZA24='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)