UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zC3lYuLf88GFIvlu9IALgGxewgYC6BIOseq0Do/u4Y0='
WHERE
key_id = '71f4587a10ae20e184e57ce2cf689631a6b2f7c33add52d96eda3f2f0a6928e4'
AND (
token = 'zC3lYuLf88GFIvlu9IALgGxewgYC6BIOseq0Do/u4Y0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)