UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BG/IvsqGqf72FGWj6w9szb+6lPlSJE6R9yZh0NZThbA='
WHERE
key_id = 'd9362240342b69a9b1759a0c434393e4625315ee5239e37e6734ffc952b1c3ed'
AND (
token = 'BG/IvsqGqf72FGWj6w9szb+6lPlSJE6R9yZh0NZThbA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)