UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/eKxFaKGtPoA51ParV2LbwiPfIIl4vtMEsN2sYggIKQ='
WHERE
key_id = 'ec0652669c39bf8de07946dace585df56a277e4d9c33d313459d2b57a7df67e4'
AND (
token = '/eKxFaKGtPoA51ParV2LbwiPfIIl4vtMEsN2sYggIKQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)