UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nz/h4Q1mIblvMpfvPZCB6mukNOHSU6o0Liikj7fvIoI='
WHERE
key_id = '7ad9d4ac668d5c0b92c03a818960a21a7670c4a83a9401264358c26958e6ea21'
AND (
token = 'nz/h4Q1mIblvMpfvPZCB6mukNOHSU6o0Liikj7fvIoI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)