UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nW4+48WbZz5hbhwovNltHXws++OMVTYl411ZZA0T2YM='
WHERE
key_id = 'f9c030eb28bf0848ecfb192094f133be4d3e0cfa5e787b1b08e86d4fe1fc94d9'
AND (
token = 'nW4+48WbZz5hbhwovNltHXws++OMVTYl411ZZA0T2YM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)