UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hjLUu4luL3zPyWsN+iYIZOqedUe3itcaIL3l4YL+E58='
WHERE
key_id = '026b8ea4fbdb41586ce288fd2e8d2d6ce96b404f623a2fc86d3f98b8dcb6dab3'
AND (
token = 'hjLUu4luL3zPyWsN+iYIZOqedUe3itcaIL3l4YL+E58='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)