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