UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qAwI5v+9WxIA4z0oSDJS8ODLABvcVFWqcztJ3h5NoxI='
WHERE
key_id = '6046b42caaaf9b597410cf7c4b91b3244b5a4bbbe3ca8bea79cab7067c6e59cc'
AND (
token = 'qAwI5v+9WxIA4z0oSDJS8ODLABvcVFWqcztJ3h5NoxI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)