UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7Id0k/HcU6AF5YrdhaOIGLccZQHlTxD9Yk55BsYWnbM='
WHERE
key_id = 'a4441fdb05a7936bfb2a3aeaeddff5882e6ada70da60f374a8a532264d989430'
AND (
token = '7Id0k/HcU6AF5YrdhaOIGLccZQHlTxD9Yk55BsYWnbM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)