UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7FTWs5vav4gRky6Xl6RbkIEjQaHb9ifCzep1RWNviho='
WHERE
key_id = '1a089a7f80bb32f5b539ab8ed00aedd2d0f12c02bd02039cc206cc5a65f30db7'
AND (
token = '7FTWs5vav4gRky6Xl6RbkIEjQaHb9ifCzep1RWNviho='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)