UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kpLkONJoNSdGBiU+gaO5gAFmyPqlfJlh9kgLrK+o6mo='
WHERE
key_id = '2030bfa60d707bbb6e54e2d036ca9b1773e6c12aad3f5545abdb91de562ffcbb'
AND (
token = 'kpLkONJoNSdGBiU+gaO5gAFmyPqlfJlh9kgLrK+o6mo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)