UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rnFpnl9Vw8GlsddVn2GIZ2XZi0mE5NVSl+LU+Y/zVN0='
WHERE
key_id = '3e2996e69daa684f61e521a589582e4e77f0607263162b1b2732a86044ce6872'
AND (
token = 'rnFpnl9Vw8GlsddVn2GIZ2XZi0mE5NVSl+LU+Y/zVN0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)