UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LZcvt9vCdw08L2oULXAbxNJ4JTcawz8DUV6G+nYlVb0='
WHERE
key_id = '19b69e8bf8787628592341f7fb0db39f6a02c289e7a3eb0dbdf98b04872a63c3'
AND (
token = 'LZcvt9vCdw08L2oULXAbxNJ4JTcawz8DUV6G+nYlVb0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)