UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QsrxCofX+2Z4nomng1sIQQmP88TeJkIMA+4Ut15qexY='
WHERE
key_id = '127cff9d8caa514ef66a83ad8c5bac829c588572e8580260c74e42e5c1a06a0f'
AND (
token = 'QsrxCofX+2Z4nomng1sIQQmP88TeJkIMA+4Ut15qexY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)