UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ts8yNC4zQg5mFhHkDaVM1c43iV7fgBvJ+DG0HVcsYTA='
WHERE
key_id = 'b31c6f3792d2600b79f94f83e547e5e5f2fce9109953943687c3d69febc5ae9a'
AND (
token = 'ts8yNC4zQg5mFhHkDaVM1c43iV7fgBvJ+DG0HVcsYTA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)