UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NXQEiTZxwx2lTV1TVWPwdN+phgwLWn+h0GVqrV+OpUI='
WHERE
key_id = '2f47aa423625951b14844d1034fc866e02eeff747e6a7149df99d0898b73710b'
AND (
token = 'NXQEiTZxwx2lTV1TVWPwdN+phgwLWn+h0GVqrV+OpUI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)