UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uQ/J+eaGmVkWjXsby2zyh1ueEn8bXod+67wAU7IWDzc='
WHERE
key_id = '4dafc339144b9b574dd1148c89f5527e75662170702f4c85880c931c08c9f24e'
AND (
token = 'uQ/J+eaGmVkWjXsby2zyh1ueEn8bXod+67wAU7IWDzc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)