UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8SMmbBFZKp0WDBxeyyJ6pgGn4IHIAVnJRQ+5OgDEhpc='
WHERE
key_id = '1e6eebcbb789ff9cb6582e3c852a4ebe0c5176aca81b74b6167dca7147d81cd6'
AND (
token = '8SMmbBFZKp0WDBxeyyJ6pgGn4IHIAVnJRQ+5OgDEhpc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)