UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S9IObOpiCT4q23CJPNxfG1dHV3jstHoPzN9++VY7MpI='
WHERE
key_id = 'ca291c0dfc8b55e9998cc813378069ad9de67c590734c25e2e8d834453b6e851'
AND (
token = 'S9IObOpiCT4q23CJPNxfG1dHV3jstHoPzN9++VY7MpI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)