UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sTQ6z5KaHVaEtDW7dwPUQ0eWGo1I5Z8PF8LnKXk6t9c='
WHERE
key_id = 'a3a86987f90f3d61ce4078360b7e9f3a6a0881a84b05a3ec8dbc9f1c61c7a705'
AND (
token = 'sTQ6z5KaHVaEtDW7dwPUQ0eWGo1I5Z8PF8LnKXk6t9c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)