UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XgooEnxbX/itny3lY60TFVkNs1ZfODRI/uv8mUHz7Zs='
WHERE
key_id = '0d59d45db8c041968d9e82ead467fd3ca9a533ede061822bb4c8123f1f8b5814'
AND (
token = 'XgooEnxbX/itny3lY60TFVkNs1ZfODRI/uv8mUHz7Zs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)