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