UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QdiyUkDS4o1rUTvRDY4Xix8lzk3asmYzgaJH8ZB3XPU='
WHERE
key_id = 'e4bb6b8a24bb882d0e38f01c476d6cfec319dcdfa182729569d2aa9230a80651'
AND (
token = 'QdiyUkDS4o1rUTvRDY4Xix8lzk3asmYzgaJH8ZB3XPU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)