UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+0PeoNbHtP/6ynzO0Cte9uDVlt55YqmwVD3MoiARKpw='
WHERE
key_id = 'b00e3d0b56dd855976507a30f431d68b6129e07ad2517104e74c1db2df9d87c7'
AND (
token = '+0PeoNbHtP/6ynzO0Cte9uDVlt55YqmwVD3MoiARKpw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)